package com.jackeys.piaems.dao.mapper;

import com.jackeys.piaems.dto.ImageInfDto;
import com.jackeys.piaems.entity.Image;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @InterfaceName: ImageMapper
 * @Description: 图片映射接口
 * @Author: Jackeys
 * @Date: 2021-06-28 16:11
 * @Version: 1.0
 */
@Mapper
public interface ImageMapper{
    //查询图片
    List<Image> queryImageBySize(@Param("start") Integer start, @Param("size") Integer size);
    //查询图片数量
    Integer selectCntImage();
    /*插入图片*/
    Boolean insertImage(@Param("image")String image,@Param("date") String date);

    //查询条件图片
    List<Image> queryImageBySizeAndCondition(@Param("start") Integer start,  @Param("size") Integer size,@Param("condition")String condition);
    //查询条件图片数量
    Integer selectCntImageByCondition(@Param("condition")String condition);
    //查询数量和日期
    List<ImageInfDto> selectCntAndDate();
}
